Previous Topic

Next Topic

Query example: Upcoming tasks display

This example shows how to define a query to display upcoming tasks for a specific Opportunity Owner on their home page.

  1. From IFC, select Query Architect.
  2. Select Opportunity Management> Default System> Queries.
  3. Click New.
  4. Select the sources for the query:
    1. Select the desired business objects:
      • TaskItem
      • GroupMemberSummary
      • User
      • OpportunitySales
      • Opportunity
    2. Define the relationships between the business objects:
      • TaskItem.AssignedToKey = GroupMemberSummary.GroupKey
      • GroupMemberSummary.UserKey = User.UniformKey
      • GroupMemberSummary.GroupKey = OpportunitySales.OwnerGroupKey
      • OpportunitySales.OpportunityId = Opportunity.Opportunity.Id
  5. Define the filtering rules:
    1. Select Filters.
    2. Select Mode: Advanced.
    3. Select Property: User.Login.
    4. Select Comparison: Equal.
    5. Enter "Marc Risse" for the Value.
  6. Add the first filter.
    1. Select Property: TaskItem.Completed On.
    2. Select Comparison: Empty.
  7. Add the second filter.
    1. Select Property: Opportunity.Status.
    2. Select Comparison: Not Equal.
    3. Select Value: Closed.
  8. Define the columns to display in the output:
    1. Click the Display tab.
    2. Select the following columns and order:
      Opportunity.Uniform_Key
      Alias: key_Uniformkey (Order 1)
      OpportunitySales.Opportunity Id (Order 2)
      OpportunitySales.Description (Order 3)
      TaskItem.StartDate (Order 4)
      TaskItem.Category (Order 5)
      TaskItem.Due Date (Order 6)
      TaskItem.Subject (Order 7)
      TaskItem.Priority (Order 8)
      OpportunitySales.Quality (Order 9)
      OpportunitySales.WinProbability (Order 10)
  9. Click Save As and save the query in the Task List folder. (Tasks> Default System> Queries> TaskList)

See Also

Editing query result displays


ASI logo 10.6 Production Release. Updated 1/17/2006 4:18:18 PM
© Copyright by Advanced Solutions International, Inc. All rights reserved.